SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_FacultyActivities_Update]
	(
		@param_JOL_FacultyActivities_ID Int ,
		@param_JOL_FacultyActivities_Faculty NVarChar(50) ,
		@param_JOL_FacultyActivities_FacultyID VarChar(50) ,
		@param_JOL_FacultyActivities_Type NVarChar(50) ,
		@param_JOL_FacultyActivities_Title NVarChar(100) ,
		@param_JOL_FacultyActivities_Site NVarChar(100) ,
		@param_JOL_FacultyActivities_StartTime DateTime ,
		@param_JOL_FacultyActivities_EndTime DateTime ,
		@param_JOL_FacultyActivities_Host NVarChar(50) ,
		@param_JOL_FacultyActivities_Organizers NVarChar(50) ,
		@param_JOL_FacultyActivities_Participants NVarChar(50) ,
		@param_JOL_FacultyActivities_Introduction NText ,
		@param_JOL_FacultyActivities_Comment NText ,
		@param_JOL_FacultyActivities_WorkRecord NText ,
		@param_JOL_FacultyActivities_UpdateTime DateTime ,
		@param_JOL_FacultyActivities_UpdateUser NVarChar(50)
	)
AS
	UPDATE dbo.JOL_FacultyActivities
	SET JOL_FacultyActivities_Faculty = @param_JOL_FacultyActivities_Faculty ,
		JOL_FacultyActivities_FacultyID = @param_JOL_FacultyActivities_FacultyID ,
		JOL_FacultyActivities_Type = @param_JOL_FacultyActivities_Type ,
		JOL_FacultyActivities_Title = @param_JOL_FacultyActivities_Title ,
		JOL_FacultyActivities_Site = @param_JOL_FacultyActivities_Site ,
		JOL_FacultyActivities_StartTime = @param_JOL_FacultyActivities_StartTime ,
		JOL_FacultyActivities_EndTime = @param_JOL_FacultyActivities_EndTime ,
		JOL_FacultyActivities_Host = @param_JOL_FacultyActivities_Host ,
		JOL_FacultyActivities_Organizers = @param_JOL_FacultyActivities_Organizers ,
		JOL_FacultyActivities_Participants = @param_JOL_FacultyActivities_Participants ,
		JOL_FacultyActivities_Introduction = @param_JOL_FacultyActivities_Introduction ,
		JOL_FacultyActivities_Comment = @param_JOL_FacultyActivities_Comment ,
		JOL_FacultyActivities_WorkRecord = @param_JOL_FacultyActivities_WorkRecord ,
		JOL_FacultyActivities_UpdateTime = @param_JOL_FacultyActivities_UpdateTime ,
		JOL_FacultyActivities_UpdateUser = @param_JOL_FacultyActivities_UpdateUser
	WHERE JOL_FacultyActivities_ID = @param_JOL_FacultyActivities_ID
GO
